
CREATE TABLE [dbo].[Saving_Log](
	[SavingID_log] [bigint] NOT NULL,
	[SavingID] [bigint] NOT NULL,
	[SavingNo] [varchar](50) NOT NULL,
	[SavingDate] [datetime] NOT NULL,
	[DefaultBranchID] [bigint] NOT NULL,
	[CreatedBy] [bigint] NOT NULL,
	[ModifiedBy] [bigint] NOT NULL,
	[CreatedDate] [datetime] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
	[AgentID] [bigint] NOT NULL,
	[AgentCode] [varchar](50) NOT NULL,
	[NRC] [nvarchar](50) NOT NULL,
	[Address] [nvarchar](2000) NOT NULL,
	[Phoneno] [varchar](50) NOT NULL,
	[CurrencyID] [bigint] NOT NULL,
	[Rate] [decimal](18, 4) NOT NULL,
	[Amount] [decimal](18, 4) NOT NULL,
	[BankID] [bigint] NULL,
	[BankCode] [nvarchar](50) NOT NULL,
	[TransactionType] [tinyint] NOT NULL,
	[log_sysDate] [datetime] NOT NULL,
	[log_userid] [bigint] NOT NULL,
	[log_status] [tinyint] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


